![]() | ![]() | ![]() | ![]() | ![]() |
SAS Real-Time Decision Manager enables you to load treatment custom details using the sasciutils utility program. However, sasciutils returns an error if you attempt to load a list-type custom detail for which the LIST_DISPLAY_VALUE_COLUMN column or LIST_VALUE_COLUMN field is empty:
... Unable to read list item table VALUES for custom detail <variable name> in treatment <treatment name>. ... Unable to execute query: SQL passthru expression contained these errors: ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, FROM, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.... ERROR 22-322: Syntax error, expecting one of the following: a quoted string, !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, AS, BETWEEN, CONTAINS, EQ, EQT, FORMAT, FROM, GE, GET, GT, GTT, IN, INFORMAT, INTO, IS, LABEL, LE, LEN, LENGTH, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, TRANSCODE, ^, ^=, |, ||, ~, ~=. 22: LINE and COLUMN cannot be determined.... NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.... ERROR 76-322: Syntax error, statement will be ignored. 76: LINE and COLUMN cannot be determined.... NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS Real-Time Decision Manager | Microsoft® Windows® for x64 | 6.3 | 6.4 | 9.4 TS1M0 | |
64-bit Enabled AIX | 6.3 | 6.4 | 9.4 TS1M0 | |||
64-bit Enabled Solaris | 6.3 | 6.4 | 9.4 TS1M0 | |||
HP-UX IPF | 6.3 | 6.4 | 9.4 TS1M0 | |||
Linux for x64 | 6.3 | 6.4 | 9.4 TS1M0 | |||
Solaris for x64 | 6.3 | 6.4 | 9.4 TS1M0 |